package com.stone.business.workcard.action;

import java.util.HashMap;
import java.util.List;

import com.stone.sys.service.SysCommonService;

import frm.ssh.action.BaseListAction;
import frm.ssh.util.page.Page;

public class QxtjListAction extends BaseListAction {
	private SysCommonService myService;	

	 
	@Override
	public HashMap<String, Object> setSearchCondition() {	
		HashMap<String, Object> m = new HashMap<String, Object>();
		StringBuffer sql = new StringBuffer();
		sql.append("select (select t.organ_name from sys_organ t where t.id=2) as bzname,get_finishrate('','"+super.getSearchBean().getCon1()+"','3') as three, get_finishrate('','"+super.getSearchBean().getCon1()+"','8') as eight, get_finishrate('','"+super.getSearchBean().getCon1()+"','') as zong from  dual");
		sql.append(" union all ");
		sql.append("select (select t.organ_name from sys_organ t where t.id=21) as bzname,get_finishrate('21','"+super.getSearchBean().getCon1()+"','3') as three, get_finishrate('21','"+super.getSearchBean().getCon1()+"','8') as eight, get_finishrate('21','"+super.getSearchBean().getCon1()+"','') as zong from  dual");
		sql.append(" union all ");
		sql.append("select (select t.organ_name from sys_organ t where t.id=22) as bzname,get_finishrate('22','"+super.getSearchBean().getCon1()+"','3') as three, get_finishrate('22','"+super.getSearchBean().getCon1()+"','8') as eight, get_finishrate('22','"+super.getSearchBean().getCon1()+"','') as zong from  dual");
		sql.append(" union all ");
		sql.append("select (select t.organ_name from sys_organ t where t.id=23) as bzname,get_finishrate('23','"+super.getSearchBean().getCon1()+"','3') as three, get_finishrate('23','"+super.getSearchBean().getCon1()+"','8') as eight, get_finishrate('23','"+super.getSearchBean().getCon1()+"','') as zong from  dual");
		m.put("pageflag", "sql");		
		m.put("sql", sql.toString());
		return m;
	}

	public SysCommonService getMyService() {
		return myService;
	}

	public void setMyService(SysCommonService myService) {
		this.myService = myService;
		this.service=myService;
	}

}
